CREATE EXTERNAL TABLE jms_dwd.dwd_yl_oms_interceptorrecord_base_dt(
  `waybill_no` string COMMENT '运单编号', 
  `interceptor_piece_id` bigint COMMENT '拦截件id', 
  `intercept_network_id` bigint COMMENT '拦截网点id', 
  `intercept_network_name` string COMMENT '拦截网点名称', 
  `intercept_network_code` string COMMENT '拦截网点编码', 
  `intercept_id` bigint COMMENT '拦截人ID', 
  `intercept_name` string COMMENT '拦截人名称', 
  `intercept_code` string COMMENT '拦截人编码', 
  `intercept_time` timestamp COMMENT '拦截时间', 
  `scan_time` timestamp COMMENT '扫描时间', 
  `operation_source` string COMMENT '扫描时间')
COMMENT '拦截件扫描表'
PARTITIONED BY ( 
  `dt` string COMMENT '更新/创建日期 (yyyy-MM-dd)')
STORED AS parquet
LOCATION
  '/dw/hive/jms_dwd.db/external/dwd_yl_oms_interceptorrecord_base_dt'
;